Chris Pollett > Old Classes >
CS157a

( Print View )

Grades: [Sec4]

Submit: [Sec4]

Course Info:
  [Texts & Links]
  [Topics]
  [Grading]
  [HW Info]
  [Exam Info]
  [Regrades]
  [Honesty]
  [Announcements]

HW Assignments:
  [Hw1]  [Hw2]  [Hw3]
  [Hw4]  [Hw5]

Practice Exams:
  [Mid1]  [Mid2]  [Final]

                            












HW#2 --- last modified January 01 1970 00:00:00..

Solution set.

Due date: Feb 27

Files to be submitted:
  Ch2Ch3Probs.doc
  OracleScript.doc

Purpose:To become more familiar with ER and EER modeling. To get going with Oracle accounts on sigma.

Specification:

Turn in the following exercises from Ch3 and Ch4 of E&N in the file Ch2Ch3Probs.doc: 3.16 (use char graphics the best you can), 3.23, 4.20. The file OracleScript.doc is a text file gotten using the script command (To find out about script do man script). It should contains a session of you connecting to your Oracle account and querying the user_tables to display all the tables in your oracle account.

Point Breakdown

3.16 & 3.23 each subitem = 1/2pt5.5pts
4.20 each bulleted item handled=1/4pt 2.5pt
Connect to Oracle account on sigma1pt
Querying user tables 1pt
Total10pts